Scatter Chart - Satisfaction and Workload Impact on Attrition
18
1. Dimension and Placement: Create a Scatter Chart
from the Visualizations pane. Set the dimensions to 331x367 and
position it at Horizontal: 912 and Vertical: 388 on the dashboard.
2. Data Configuration:
Set "Project Cnts" as the Values. Assign "Avg Monthly Hrs" for the
X-axis and "Satisfaction %" for the Y-axis to dissect the correlation
between workload and employee satisfaction against attrition.
3. Marker and Color Settings:
Adjust the marker size to 29. For coloring, apply conditional
formatting with a gradient format based on "Attrition %". Set the
minimum value color to #F0E199 and the maximum value color to #B08F0A.
4. Axis Ranges and Formatting:
Configure the X-axis range from 150 to 300 and the Y-axis range from 0
to 0.8 to encapsulate relevant data metrics. Customize X-axis values and
titles with the color #DF1FDF, X-axis values and titles with the color
#4AC7B0 for enhanced clarity and distinction.
5. Aesthetics and Title:
- Update
the chart title to “Satisfaction and Workload Impact on Attrition”,
applying DIN font, size 14, and a background of #C7D4E8 for cohesive
visual integration.
- Disable the chart background and activate a visual border colored #999999 for clear chart definition.
- Remove
vertical and horizontal Gridlines for a streamlined appearance and set
the legend at the top center for immediate identification.
6. Create Scatter Chart for Predictive Section: Following the same process, develop corresponding Scatter Chart for
the predictive section, selecting appropriate predictive measures and
metrics for each chart. Ensure these also follow the formatting
standards and color schemes established in the historical section for
consistency.
7. Managing Visibility for Sections:
- In
the predictive section of the dashboard, select all historical charts
and hide them using the Selection Pane. Then, update the predictive
bookmark to save this state where only predictive charts are visible.
- Conversely,
in the historical section, hide all predictive charts through the
Selection Pane and update the historical bookmark to reflect this setup,
ensuring only historical charts display in this view. Finally, toggle
between the historical and predictive bookmarks to verify the correct
functionality and visibility of the charts.



Scatter charts in Power BI